﻿CREATE TABLE [dbo].[Publications] (
    [Id]                                            NVARCHAR (50)  NOT NULL,
    [Date]                                          DATETIME       NOT NULL,
    [Title]                                         NVARCHAR (MAX) NOT NULL,
    [Link]                                          NVARCHAR (MAX) NOT NULL,
    [PDFLink]                                       NVARCHAR (MAX) NOT NULL,
    [PublishingArea]                                NVARCHAR (MAX) NOT NULL,
    [Summary]                                       NVARCHAR (MAX) NOT NULL,
    [PublicationType]                               NVARCHAR (MAX) NOT NULL,
    [IndexedContent]                                NVARCHAR (MAX) NOT NULL,
    [Authors]                                       NVARCHAR (MAX) NOT NULL,
    [GenericSearchResultPublication_Publication_Id] NVARCHAR (100) NOT NULL
);





